﻿CREATE TABLE [dbo].[WebApplication_JobDefinition] (
    [WebApplicationID] UNIQUEIDENTIFIER NOT NULL,
    [JobDefinitionID]  UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_WebApplication_JobDefinition] PRIMARY KEY CLUSTERED ([WebApplicationID] ASC, [JobDefinitionID] ASC),
    CONSTRAINT [FK_WebApplication_JobDefinition_JobDefinition] FOREIGN KEY ([JobDefinitionID]) REFERENCES [dbo].[JobDefinition] ([JobDefinitionID]),
    CONSTRAINT [FK_WebApplication_JobDefinition_WebApplication] FOREIGN KEY ([WebApplicationID]) REFERENCES [dbo].[WebApplication] ([WebApplicationID])
);


GO
ALTER TABLE [dbo].[WebApplication_JobDefinition] NOCHECK CONSTRAINT [FK_WebApplication_JobDefinition_JobDefinition];

